package com.zjitc.chapter05.mapper;

import com.zjitc.chapter05.domain.Product;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ProductMapper {
    @Select("select * from product where id in (select product_id from order_item where order_id = #{orderId})")
    List<Product> selectProductsByOrderId(Integer orderId);
}
